
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_DonViQuiDoi_Insert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_DonViQuiDoi_Insert]
GO
CREATE PROC [sp_DonViQuiDoi_Insert]
	@Don_vi_goc	nvarchar(50),
	@So_Luong	Float,
	@Child_id	int , 
	@Ghi_chu	nvarchar(100)

AS
BEGIN
	INSERT INTO DonViQuiDoi(Don_vi_goc,So_luong,Child_id,Ghi_chu,Ngay_cap_nhat_cuoi)
		VALUES(
			@Don_vi_goc,
			@So_Luong,
			@Child_id,
			@Ghi_chu,
			getdate()
		)
END